package com.example.mapper;

import org.apache.ibatis.annotations.Delete;
import org.apache.ibatis.annotations.Select;

public interface BookMapper {


    /**
     * 获取课本名称
     * @return
     */
    @Select("select * from books")
    String GetBooks();

    /**
     * 删除课本相关信息
     *
     * @return
     */
    @Delete("delete from books where book_name=#{book_name}")
    Boolean DelBooks(String book_name);

    @Delete("delete from tea_choice where book_name=#{book_name}")
    Boolean DelBookAboutTea(String book_name);

    @Delete("delete from stu_choice where book_name=#{book_name}")
    Boolean DelBookAboutStu(String book_name);

    @Delete("delete from menu where book_name=#{book_name}")
    Boolean DelBookAboutMenu(String book_name);


}
